[livres divers classés par sujet] [Informatique] [Algorithmique] [Programmation] [Mathématiques] [Hardware] [Robotique] [Langage] [Intelligence artificielle] [Réseaux]
[Bases de données] [Télécommunications] [Chimie] [Médecine] [Astronomie] [Astrophysique] [Films scientifiques] [Histoire] [Géographie] [Littérature]

Universal Quantification in Relational Databases: A Classification of Data and Algorithms

contributor Anwendersoftware (IPVR)
creator Rantzau, Ralf
Shapiro, Leonard
Mitschang, Bernhard
Wang, Quan
date 2002-03
description Queries containing universal quantification are used in many applications, including business intelligence applications. Several algorithms have been proposed to implement universal quantification efficiently. These algorithms are presented in an isolated manner in the research literature - typically, no relationships are shown between them. Furthermore, each of these algorithms claims to be superior to others, but in fact each algorithm has optimal performance only for certain types of input data. In this paper, we present a comprehensive survey of the structure and performance of algorithms for universal quantification. We introduce a framework for classifying all possible kinds of input data for universal quantification. Then we go on to identify the most efficient algorithm for each such class. One of the input data classes has not been covered so far. For this class, we propose several new algorithms. For the first time, we are able to identify the optimal algorithm to use for any given input dataset. These two classifications of input data and optimal algorithms are important for query optimization. They allow a query optimizer to make the best selection when optimizing at intermediate steps for the quantification problem.
format application/postscript
1005887 Bytes
identifier  http://www.informatik.uni-stuttgart.de/cgi-bin/NCSTRL/NCSTRL_view.pl?id=INPROC-2002-01&engl=1
ISBN: 3-540-43324-4
language eng
publisher Springer
relation Lecture Notes in Computer Science; 2287
source In: Proceedings of the International Conference on Extending Database Technology (EDBT), Prague, Czech Republic, March 2002, pp. 445-463
ftp://ftp.informatik.uni-stuttgart.de/pub/library/ncstrl.ustuttgart_fi/INPROC-2002-01/INPROC-2002-01.ps
subject Database Management Systems (CR H.2.4)
query processing
relational division
physical operators
title Universal Quantification in Relational Databases: A Classification of Data and Algorithms
type Text
Article in Proceedings